diff --git a/tests/codeigniter/database/query_builder/join_test.php b/tests/codeigniter/database/query_builder/join_test.php
index 6d5fc64..25bd4ac 100644
--- a/tests/codeigniter/database/query_builder/join_test.php
+++ b/tests/codeigniter/database/query_builder/join_test.php
@@ -52,7 +52,7 @@
 				->join('table2', "table1.field1 = table2.field2 AND table1.field1 = 'foo' AND table2.field2 = 0", 'LEFT')
 				->get_compiled_select();
 
-		$this->assertEquals($sql, $result);
+		$this->assertEquals($expected, $result);
 	}
 
 }
\ No newline at end of file